# Dataset

_value:
Public - Free to use in any way you wish


_value:
VC5 and 6 Pyralids Recorded 10km squares


_value:
VC5 and 6 Pyralids Log(Species Density) 10km


_value:
VC5 and 6 Pyralidae Log(Species Density) 10km


_value:
VC5 and 6 Pyralidae Recorders and Record density


# Recorders

Comment:
Use this as Determiner for all records that are unvalidated or awaiting determination.


Comment:
originally mothing in Burnham on Sea 1997-1998


# Records

Comment:
Found inside the house at a window facing the trap - may have flow in through the patio doors.


Comment:
Still a number of tristella disturbed in nearby fields during the day - non in trap.


Comment:
Found inside, in evening flying agains the window


Comment:
In evening, attracted to a lighted window


Comment:
This is a first, not mentioned in Goater for Somerset, Voucher


Comment:
Some still alive in the morning - whic h is unusual


Comment:
In the evening, about six flying about majoram


Comment:
At night, attracted to kitchen window, 4 or 5 including a pair in cop!


Comment:
No quantity, recorded as 'common'. Recorded by Doug Miller and B & B Slade.


Comment:
No quantity, recorded as 'many'. Recorded by Keith Brown & Dixie Dean.


Comment:
At least 25 recorded. Recorded by Tony Parsons & Keith Brown.


Comment:
Recorded by Claude Morley & J Cowley. No quantity recorded.


Comment:
Recorded by Doug Miller & B & B Slade. No quantity recorded.


Comment:
Recorded by Jim Lidgate & David Lester. No quantity recorded.


Comment:
Recorded by J Robbins & B Baker. No quantity recorded.


Comment:
Recorded by Doug Miller & B. & B. Slade. No quantity recorded.


Comment:
Site given as 'north of the county'. No quantity recorded.


Comment:
Recorded by John Robbins & B. Baker. No quantity recorded.


Comment:
See also Turner (1955). No quantity recorded.


Comment:
1st County record. No quantity recorded.


Comment:
Recorded by A R Hayward & G B Coney. No quantity recorded.


Comment:
Recorded by John Robbins & Brian Baker. No quantity recorded.


Comment:
Recorded by Malcolm Cotterill & Kim Leaver. No quantity recorded.


Comment:
Recorded by Doug Miller & B. & B. Slade.


Comment:
At least 7 recorded by Jim Lidgate & B & B Slade.


Comment:
Recorded by Keith Brown & Jeremy Burge. No quantity recorded.


Comment:
Recorded by Keith Brown & Tony Parsons. No quantity recorded.


Comment:
Considered erroneous. No quantity recorded.


Comment:
At least 2 recorded by Doug Miller & B & B Slade.


Comment:
At least 3 recorded by Doug Miller & B & B Slade.


Comment:
At least * recorded by Doug Miller & B & B Slade.


Comment:
Recorded by A.R. Hayward & C.J. Perrens. No quantity recorded.


Comment:
Recorded by Jim Lidgate  & David Lester. No quantity recorded.


Comment:
Recorded by Dixie Dean & Bill Urwin. No quantity recorded.


Comment:
Breeding resident. No quantity recorded.


Comment:
Recorded by Brian Slade & Andrew Duff. No quantity recorded.


Comment:
Recorded as 'first county record'. No quantity recorded.


Comment:
Reocrded by Doug Miller & B. & B. Slade.


Comment:
Recorded by Morley, Turner and Cowley. No quantity recorded.


Comment:
Recorded by A.R. Hayward & G.B. Coney. No quantity recorded.


Comment:
Recorded as 'North Somerset'. No quantity recorded.


Comment:
See also Turner (1955).  No quantity recorded.


Comment:
See also Skinner & Parsons (1998a). No quantity recorded.


Comment:
Several larvae in stem of Artemisia vulgaris


Comment:
Recorded by Dixie Dean & David Lester. No quantity recorded.


Comment:
Recorded by Jim Lidgate & Dixie Dean. No quantity recorded.


Comment:
Recorded as 'South Somerset'. No quantity recorded.


Comment:
At least 17 recorded by Leaver, Lidgate, Slade & Miller.


Comment:
Recorded by Dixie Dean & Malcolm Cotterill. No quantity recorded.


Comment:
Latest on 18/12/96! No quantity recorded.


Comment:
Transitory resident - continuously brooded? No quantity recorded.


Comment:
Transitory resident - continuously brooded? O1444No quantity recorded.


Comment:
Recorded by John Robins & Brian Baker. No quantity recorded.


Comment:
1000 per night! (See Reid 1998). No quantity recorded.


Comment:
Transitory resident. No quantity recorded.


Comment:
See also Chalmers-Hunt (1986). No quantity recorded.


Comment:
Recorded by Dixie Dean & Jim Lidgate. No quantity recorded.


Comment:
At least 12 recorded by Leaver, Lidgate, Slade & Miller.


Comment:
At least 7 recorded by Brown, Cotterill & Parsons.


Comment:
Recorded by Slade, Leaver, Lidgate & Miller.


Comment:
Needs confirmation. No quantity recorded.


Comment:
12m S of Leigh Woods. No quantity recorded.


Comment:
See also Parsons (1993)No quantity recorded.


Comment:
See also Waring (1996). No quantity recorded.


Comment:
Unconfirmed - not accepted by National Pyralid Scheme


Comment:
At least 13 recorded by Brown, Cotterill, Miller & Slade.


Comment:
Confirmed by D. Slade. No quantity recorded.


Comment:
Perhaps H. saxicola. No quantity recorded.


Comment:
Recorded by G.B. Coney & A. R. Hayward. No quantity recorded.


Comment:
noted while 7 conifers were being felled in the garden


# References

Title:
Unpublished records from East Brent in 2000


Comment:
E-mail with Somerset records to Martin Ellis


Title:
The Immigration of Lepidoptera to the British Isles in 1997, In: Ent. Rec. 112


Title:
Microlepidoptera - A Review of the Year 1990, In: Ent. Rec. 104


Author:
Agassiz, D. J. L., Heckford, R. and Langmaid, J.

Title:
Microlepidoptera - A Review of the Year 1993, In: Ent. Rec. 105


Title:
Microlepidoptera - A Review of the Year 1992, In: Ent. Rec. 106


Title:
Microlepidoptera - A Review of the Year 1994, In: Ent. Rec. 108


Title:
Microlepidoptera - A Review of the Year 1995, In: Ent. Rec. 109


Author:
Bretherton, R. F. and Chalmers-Hunt, J. M.

Title:
Immigration of Lepidoptera Into The British Isles 1983, In: Ent. Rec. 96


Title:
Collecting Notes 1995, In: Ent. Rec. 108


Title:
Collecting Notes 1996, In: Ent. Rec. 109


Title:
Zoology 1968 Lepidoptera, In: Proc. Som. Ant. Nat. Hist. Soc. 113


Title:
Microlepidoptera Records from Somerset, In: Ent. Rec. 98


Title:
A Review of the Scarce and Threatened Pyralid Moths of Great Britain


Title:
The immigration of Lepidoptera to the British Isles in 1992, In: Ent. Rec. 108


Title:
County Focus - The Bristol District, In: Atropos 5


Author:
Somerset Archaeological & Natural History Society

Title:
Proceedings of the Somerset Archaeological & Natural History Society.  1912 - 1994

Comment:
This is a general reference, colated by Martin Ellis for Ellis (1999).


Title:
Moth Records from Stoke Sub Hamdon, Somerset in 1997.  Unpublished.


Title:
Moth Records from West Coker, Somerset in 1995.  Unpublished.


Title:
Moth Records from Stoke Sub Hamdon, Somerset in 1998.  Unpublished.


Title:
Moth Records from Stoke Sub Hamdon, Somerset in 1999.  Unpublished.


Title:
Somerset Moth Group, Newsletter 2 - October 1993


Title:
Somerset Moth Group, Newsletter 21 - August 1998


Title:
Pyralidae, Pterophoridae & Alucitidae Records in Somerset

Comment:
Synpopsis of all SMG, published and historic records for Somerset


Title:
Microlepidoptera - A Review of the Year 1985, In: Ent. Rec. 99


Title:
Microlepidoptera - A Review of the Year 1988, In: Ent. Rec. 102


Title:
Records of Lepidoptera, mainly taken at light, in Yeovil: 1982 to 1999.  Unpublished.

Comment:
Data taken from John Day`s Mpro files on 31 Oct 1999 and imported into this database.


Comment:
Based on BDMG Atlas (Jan 1996) & BNS Proc. 1980 - 1995


Title:
National Pyralid & Plume Recording Scheme


Comment:
Extracted from James McGill`s Excel Files 19XXmothrecords-cresswellavenue on 19 Nov 1999.


Title:
Unpublished records of Lepidoptera at Stoke Sub Hamdon, Somerset in 2000


Title:
Provisional Atlas for the Micro-Moths of the Bristol District


# Sites

Description:
Tony Parsons' garden, Tower Hill Road Crewkerne


Description:
Mark Yeates' garden - The White House, Montacute Road, Stoke Sub Hamdon


Description:
Site visited on 14 Aug 1993 by members of the SMG


Description:
Turn Hill and Beer Wood, National Trust and Somerset Wildlife Trust property


Description:
Unable to find a Blackmoor in ST45 - unable to give more precise grid ref.


Description:
Peter Tennant's Garden Trap Site, Wiveliscombe


Description:
Fields to the south east of the reservoir. Bill Urwin 1999


Description:
Various sites within 500 metres of the map ref


Description:
Exmoor Natural History Society Field Centre


Description:
Somerset Wildlife Trust Reserve - semi-natural grassland with a mixture of rough, semi-improved grassland, better quality neutral grassland and calcareous grassland


Description:
sub-compartment of Middledown Reserve, SWT


# Taxa

Comment:
Use this taxon for unidentified species in Lepidoptera: Pterophoridae


Comment:
Adventive.  First record 1997 Spurn, Yorks.  Native of North America.


Comment:
Status uncertain.  Possibly a form of S. bipunctidactyla


Comment:
Top classification for all life - plants and animals


# VC5 and 6 Pyralidae Log(Species Density) 10km

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$VC5 and 6$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
VC5 and 6 Pyralidae Log(Species Density) 10km

Glyph:
VC5 and 6 Pyralidae Log(Species Density) 10km


SQL:
SELECT Log(Count([U\Sites and Species 10k].[*Taxon])) AS [Value], [U\Sites and Species 10k].[10kSquare] AS Gridref FROM [U\Sites and Species 10k] GROUP BY [U\Sites and Species 10k].[10kSquare]


# VC5 and 6 Pyralidae Recorders and Record density

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$VC5 and 6$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
VC5 and 6 Pyralidae Recorders and Record density

Glyph:
VC5 and 6 Pyralidae and Pterophoridae Special


SQL:
SELECT DISTINCT 1 AS [Value], [Sites\Default].OSGridRef AS Gridref FROM ((Records INNER JOIN Recorders ON Records.[*Recorder] = Recorders.[_guk]) INNER JOIN [Sites\Default] ON Recorders.[*Location] = [Sites\Default].[_guk]) INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk] Where [Sites\Default].[OSGridRef] <> ''


SQL:
SELECT Log(Count([Records].[*Taxon])+1) AS [Value], [Sites\Default].[10kSquare] AS Gridref FROM (Records INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk]) INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk] GROUP BY [Sites\Default].[10kSquare]


# VC5 and 6 Pyralidae Records vs Species

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$VC5 and 6$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
VC5 and 6 Pyralidae species and record density

Glyph:
VC5 and 6 Pyralidae and Pterophoridae Special


SQL:
SELECT Count([Records].[*Taxon]) AS [Value], [Sites\Default].[10kSquare] AS Gridref FROM (Records INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk]) INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk] GROUP BY [Sites\Default].[10kSquare]


SQL:
SELECT Log(Count([U\Sites and Species 10k].[*Taxon])) AS [Value], [U\Sites and Species 10k].[10kSquare] AS Gridref FROM [U\Sites and Species 10k] GROUP BY [U\Sites and Species 10k].[10kSquare]


# VC5 and 6 Pyralids 2 km Atlas

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$VC5 and 6$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
1293 Chrysoteuchia culmella (Garden Grass-veneer)


SQL:
SELECT Count(Records.[*Taxon]) AS [Value], (Int([Xpos] / 2000) * 2000 + 2000/2) As [Xposition],  (Int([Ypos] / 2000) * 2000 + 2000/2) As [Yposition] FROM (Records INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk]) INNER JOIN Taxa ON Records.[*Taxon] = Taxa.[_guk] WHERE (((Taxa.[**RefersTo])='$subject$')) And ([Sites].[_precision] <= 2000)  Group By (Int([Xpos] / 2000) * 2000 + 2000/2), (Int([Ypos] / 2000) * 2000 + 2000/2)


Feature:
1288 Alucita hexadactyla (Twenty-plume Moth)


Feature:
1314 Catoptria margaritella (Pearl-band Grass Veneer)


Feature:
1331 Acentria ephemerella (Water Veneer)


Feature:
1345 Elophila nymphaeata (Brown China-mark)


Feature:
1348 Parapoynx stratiotata (Ringed China-mark)


Feature:
1350 Nymphula stagnata (Beautiful China-mark)


Feature:
1354 Cataclysta lemnata (Small China-mark)


Feature:
1356 Evergestis forficalis (Garden Pebble)


Feature:
1360 Hellula undalis (Old World Webworm)


Feature:
1375 Ostrinia nubilalis (European Corn Borer)


Feature:
1376 Eurrhypara hortulata (Small Magpie)


Feature:
1405 Pleuroptya ruralis (Mother of Pearl)


Feature:
1413 Hypsopygia costalis (Gold Triangle)


Feature:
1458 Myelois circumvoluta (Thistle Ermine)


Feature:
1460 Apomyelois ceratoniae (Locust Bean Moth)


Feature:
1475 Ephestia kuhniella (Mediterranean Flour Moth)


Feature:
1479 Plodia interpunctella (Indian Meal Moth)


Feature:
1513 Pterophorus pentadactyla (White Plume Moth)


SQL:
SELECT DatePart('ww',Records.[Date]) AS Week, Count(*) AS Records, Sum(Records.Quantity) AS Individuals FROM ((Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk]) INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk]) INNER JOIN TaxonStage ON Records.[*Stage] = TaxonStage.[_guk] WHERE [Records].[DateTo]-[Records].[Date]<=2 AND [Taxa\Default].[**RefersTo]='<thistaxonguk>' AND TaxonStage.Mature GROUP BY DatePart('ww',Records.[Date])


Feature:
Text Query: Status: <status> (for current species)

SQL:
SELECT 'UK Status: ' & TaxonStatus.Status as [Value] FROM Taxa INNER JOIN TaxonStatus ON Taxa.[*Status] = TaxonStatus.[_guk] WHERE Taxa.[_guk]='$subject$'


Feature:
Text Query: <n> Records (for current species)

SQL:
SELECT Count(*) & ' Records' as [Value] FROM (Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk]) INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk] WHERE [*Taxon]='$subject$';


Feature:
Text Query: <n> Sites (for current species)

SQL:
SELECT Count(*) & ' Sites' AS [Value] FROM [Sites\Default] WHERE [Sites\Default].Name & [Sites\Default].[OSGridRef] IN (SELECT [Sites\Default].Name & [Sites\Default].[OSGridRef] AS [Value] FROM [Sites\Default] INNER JOIN Records ON [Sites\Default].[_guk] = Records.[*Site] WHERE ((([Records].[*Taxon])='$subject$') AND ((Sites.[_precision])<=5000)) GROUP BY [Sites\Default].Name & [Sites\Default].[OSGridRef]);


# VC5 and 6 Pyralids 5 km Atlas

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$Somerset$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
1293 Chrysoteuchia culmella (Garden Grass-veneer)


SQL:
SELECT Count(Records.[*Taxon]) AS [Value], (Int([Xpos] / 5000) * 5000 + 5000/2) As [Xposition],  (Int([Ypos] / 5000) * 5000 + 5000/2) As [Yposition] FROM (Records INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk]) INNER JOIN Taxa ON Records.[*Taxon] = Taxa.[_guk] WHERE (((Taxa.[**RefersTo])='$subject$')) And ([Sites].[_precision] <= 5000)  Group By (Int([Xpos] / 5000) * 5000 + 5000/2), (Int([Ypos] / 5000) * 5000 + 5000/2)


Feature:
1288 Alucita hexadactyla (Twenty-plume Moth)


Feature:
1314 Catoptria margaritella (Pearl-band Grass Veneer)


Feature:
1331 Acentria ephemerella (Water Veneer)


Feature:
1345 Elophila nymphaeata (Brown China-mark)


Feature:
1348 Parapoynx stratiotata (Ringed China-mark)


Feature:
1350 Nymphula stagnata (Beautiful China-mark)


Feature:
1354 Cataclysta lemnata (Small China-mark)


Feature:
1356 Evergestis forficalis (Garden Pebble)


Feature:
1360 Hellula undalis (Old World Webworm)


Feature:
1375 Ostrinia nubilalis (European Corn Borer)


Feature:
1376 Eurrhypara hortulata (Small Magpie)


Feature:
1405 Pleuroptya ruralis (Mother of Pearl)


Feature:
1413 Hypsopygia costalis (Gold Triangle)


Feature:
1458 Myelois circumvoluta (Thistle Ermine)


Feature:
1460 Apomyelois ceratoniae (Locust Bean Moth)


Feature:
1475 Ephestia kuhniella (Mediterranean Flour Moth)


Feature:
1479 Plodia interpunctella (Indian Meal Moth)


Feature:
1513 Pterophorus pentadactyla (White Plume Moth)


Feature:
Text Query: Status: <status> (for current species)

SQL:
SELECT 'UK Status: ' & TaxonStatus.Status as [Value] FROM Taxa INNER JOIN TaxonStatus ON Taxa.[*Status] = TaxonStatus.[_guk] WHERE Taxa.[_guk]='$subject$'


Feature:
Text Query: <n> Records (for current species)

SQL:
SELECT Count(*) & ' Records' as [Value] FROM (Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk]) INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk] WHERE [*Taxon]='$subject$';


Feature:
Text Query: <n> Sites (for current species)

SQL:
SELECT Count(*) & ' Sites' AS [Value] FROM [Sites\Default] WHERE [Sites\Default].Name & [Sites\Default].[OSGridRef] IN (SELECT [Sites\Default].Name & [Sites\Default].[OSGridRef] AS [Value] FROM [Sites\Default] INNER JOIN Records ON [Sites\Default].[_guk] = Records.[*Site] WHERE ((([Records].[*Taxon])='$subject$') AND ((Sites.[_precision])<=5000)) GROUP BY [Sites\Default].Name & [Sites\Default].[OSGridRef]);


# VC5 and 6 Pyralids Log(Species Density) 10km

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$VC5 and 6$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
VC5 and 6 Pyralidae Log(Species Density) 10km

Glyph:
VC5 and 6 Pyralidae and Pterophoridae Log(Species Density) 10km


SQL:
SELECT Log(Count([U\Sites and Species 10k].[*Taxon])) AS [Value], [U\Sites and Species 10k].[10kSquare] AS Gridref FROM [U\Sites and Species 10k] GROUP BY [U\Sites and Species 10k].[10kSquare]


# VC5 and 6 Pyralids Recorded 10km squares

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$VC5 and 6$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
VC5 and 6 Pyralidae and Pterophoridae Recorded 10km squares

Glyph:
VC5 and 6 Pyralidae and Pterophoridae Recorded 10km squares


SQL:
SELECT DISTINCT 1 AS [Value], [Sites\Default].[10kSquare] AS Gridref FROM (Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk]) INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk] Where [Sites\Default].[10kSquare] <> ''


SQL:
SELECT DISTINCT 1 AS [Value], [Sites\Default].[2kSquare] AS Gridref FROM (Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk]) INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk] Where [Sites\Default].[2kSquare] <> ''


# VC5 and 6 Pyralids Recorded Sites 2km

Glyph:
$taxadef$Lepidoptera: Pyralidae and Pterophoridae$sitedef$VC5 and 6$subject$SELECT DISTINCT iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "") AS FeatureName, [_guk] AS FeatureItem FROM [Taxa\Default] WHERE ([_guk] = [**RefersTo]) ORDER BY iif([Code] <> "", [Code] & " ", "") & Taxon & iif(Vernacular <> "", " (" & Vernacular & ")", "")


Feature:
VC5 and 6 Pyralidae and Pterophoridae Recorded 2km Squares

Glyph:
VC5 and 6 Pyralidae and Pterophoridae Recorded Sites 2km


SQL:
SELECT DISTINCT 1 AS [Value], [Sites\Default].[2kSquare] AS Gridref FROM (Records INNER JOIN [Taxa\Default] ON Records.[*Taxon] = [Taxa\Default].[_guk]) INNER JOIN [Sites\Default] ON Records.[*Site] = [Sites\Default].[_guk] Where [Sites\Default].[2kSquare] <> ''


